package com.iris.live.services.data.repositories;

import com.iris.live.services.data.models.报价金融表Model;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

/**
 * Created by sxy on 2016/7/13.
 */
public interface 报价金融表Repository extends JpaRepository<报价金融表Model, Integer>, JpaSpecificationExecutor<报价金融表Model> {

    @Query("select a from 报价金融表Model a where a.金融编号=?1 and a.金融机构='奔驰租赁' ")
    报价金融表Model getLatestfinalMsg(int num);

    @Query("select a from 报价金融表Model a where a.金融编号=?1  ")
    报价金融表Model getLatestfinalMsgs(int num);
}
